* Drop missing values

use "full_sample_councilors.dta", clear

drop if Q7_a_1=="" | Q7_b_1=="" | Q7_c_1 =="" | Q7_d_1=="" | Q7_e_1=="" | Q7_f_1=="" | Q7_g_1=="" | Q7_h_1==""
drop if Q25_gender=="Άλλο"
drop if Q25_gender=="Δε γνωρίζω/ Δεν απαντώ"
drop if Q26_residence_2 =="Do not know/ Do not answer"
drop Q7_a_1 Q7_b_1 Q7_c_1 Q7_d_1 Q7_e_1 Q7_f_1 Q7_g_1 Q7_h_1

save "councilors_nomiss.dta", replace
export excel using "councilors_nomiss.xlsx", firstrow(variables) replace

clear
